Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	700
Missing cells	53
Missing cells (%)	0.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	87.6 KiB
Average record size in memory	128.2 B

Variable types

Categorical	6
Numeric	9
DateTime	1

Alerts

`Sales` is highly overall correlated with `COGS` and 4 other fields	High correlation
`COGS` is highly overall correlated with `Sales` and 3 other fields	High correlation
`Discounts` is highly overall correlated with `Sales` and 3 other fields	High correlation
`Gross Sales` is highly overall correlated with `Sales` and 4 other fields	High correlation
`Manufacturing Price` is highly overall correlated with `Product`	High correlation
`Month Name` is highly overall correlated with `Month Number` and 1 other fields	High correlation
`Month Number` is highly overall correlated with `Month Name` and 1 other fields	High correlation
`Product` is highly overall correlated with `Manufacturing Price`	High correlation
`Profit` is highly overall correlated with `Sales` and 2 other fields	High correlation
`Sale Price` is highly overall correlated with `Sales` and 5 other fields	High correlation
`Segment` is highly overall correlated with `Sale Price`	High correlation
`Year` is highly overall correlated with `Month Name` and 1 other fields	High correlation
`Discount Band` has 53 (7.6%) missing values	Missing
`Country` is uniformly distributed	Uniform
`Discounts` has 53 (7.6%) zeros	Zeros

Reproduction

Analysis started	2024-11-19 13:05:21.825621
Analysis finished	2024-11-19 13:05:45.313398
Duration	23.49 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

Segment
Categorical

High correlation

Distinct	5
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	5.6 KiB

Government	300
Midmarket	100
Channel Partners	100
Enterprise	100
Small Business	100

Length

Max length	16
Median length	10
Mean length	11.285714
Min length	9

Characters and Unicode

Total characters	7900
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Government
2nd row	Government
3rd row	Midmarket
4th row	Midmarket
5th row	Midmarket

Common Values

Value	Count	Frequency (%)
Government	300	42.9%
Midmarket	100	14.3%
Channel Partners	100	14.3%
Enterprise	100	14.3%
Small Business	100	14.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
government	300	33.3%
midmarket	100	11.1%
channel	100	11.1%
partners	100	11.1%
enterprise	100	11.1%
small	100	11.1%
business	100	11.1%

Most occurring characters

Value	Count	Frequency (%)
e	1200	15.2%
n	1100	13.9%
r	800	10.1%
t	600	7.6%
m	500	6.3%
s	500	6.3%
a	400	5.1%
G	300	3.8%
o	300	3.8%
v	300	3.8%
Other values (14)	1900	24.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7900	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1200	15.2%
n	1100	13.9%
r	800	10.1%
t	600	7.6%
m	500	6.3%
s	500	6.3%
a	400	5.1%
G	300	3.8%
o	300	3.8%
v	300	3.8%
Other values (14)	1900	24.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7900	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1200	15.2%
n	1100	13.9%
r	800	10.1%
t	600	7.6%
m	500	6.3%
s	500	6.3%
a	400	5.1%
G	300	3.8%
o	300	3.8%
v	300	3.8%
Other values (14)	1900	24.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7900	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1200	15.2%
n	1100	13.9%
r	800	10.1%
t	600	7.6%
m	500	6.3%
s	500	6.3%
a	400	5.1%
G	300	3.8%
o	300	3.8%
v	300	3.8%
Other values (14)	1900	24.1%

Country
Categorical

Uniform

Distinct	5
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	5.6 KiB

Canada	140
Germany	140
France	140
Mexico	140
United States of America	140

Length

Max length	24
Median length	6
Mean length	9.8
Min length	6

Characters and Unicode

Total characters	6860
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Canada
2nd row	Germany
3rd row	France
4th row	Germany
5th row	Mexico

Common Values

Value	Count	Frequency (%)
Canada	140	20.0%
Germany	140	20.0%
France	140	20.0%
Mexico	140	20.0%
United States of America	140	20.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
canada	140	12.5%
germany	140	12.5%
france	140	12.5%
mexico	140	12.5%
united	140	12.5%
states	140	12.5%
of	140	12.5%
america	140	12.5%

Most occurring characters

Value	Count	Frequency (%)
a	980	14.3%
e	840	12.2%
n	560	8.2%
t	420	6.1%
r	420	6.1%
c	420	6.1%
	420	6.1%
i	420	6.1%
d	280	4.1%
m	280	4.1%
Other values (12)	1820	26.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6860	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	980	14.3%
e	840	12.2%
n	560	8.2%
t	420	6.1%
r	420	6.1%
c	420	6.1%
	420	6.1%
i	420	6.1%
d	280	4.1%
m	280	4.1%
Other values (12)	1820	26.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6860	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	980	14.3%
e	840	12.2%
n	560	8.2%
t	420	6.1%
r	420	6.1%
c	420	6.1%
	420	6.1%
i	420	6.1%
d	280	4.1%
m	280	4.1%
Other values (12)	1820	26.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6860	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	980	14.3%
e	840	12.2%
n	560	8.2%
t	420	6.1%
r	420	6.1%
c	420	6.1%
	420	6.1%
i	420	6.1%
d	280	4.1%
m	280	4.1%
Other values (12)	1820	26.5%

Product
Categorical

High correlation

Distinct	6
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	5.6 KiB

Paseo	202
Velo	109
VTT	109
Amarilla	94
Carretera	93

Length

Max length	9
Median length	7
Mean length	5.7328571
Min length	3

Characters and Unicode

Total characters	4013
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Carretera
2nd row	Carretera
3rd row	Carretera
4th row	Carretera
5th row	Carretera

Common Values

Value	Count	Frequency (%)
Paseo	202	28.9%
Velo	109	15.6%
VTT	109	15.6%
Amarilla	94	13.4%
Carretera	93	13.3%
Montana	93	13.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
paseo	202	28.9%
velo	109	15.6%
vtt	109	15.6%
amarilla	94	13.4%
carretera	93	13.3%
montana	93	13.3%

Most occurring characters

Value	Count	Frequency (%)
a	762	19.0%
e	497	12.4%
o	404	10.1%
r	373	9.3%
l	297	7.4%
V	218	5.4%
T	218	5.4%
P	202	5.0%
s	202	5.0%
t	186	4.6%
Other values (6)	654	16.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4013	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	762	19.0%
e	497	12.4%
o	404	10.1%
r	373	9.3%
l	297	7.4%
V	218	5.4%
T	218	5.4%
P	202	5.0%
s	202	5.0%
t	186	4.6%
Other values (6)	654	16.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4013	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	762	19.0%
e	497	12.4%
o	404	10.1%
r	373	9.3%
l	297	7.4%
V	218	5.4%
T	218	5.4%
P	202	5.0%
s	202	5.0%
t	186	4.6%
Other values (6)	654	16.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4013	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	762	19.0%
e	497	12.4%
o	404	10.1%
r	373	9.3%
l	297	7.4%
V	218	5.4%
T	218	5.4%
P	202	5.0%
s	202	5.0%
t	186	4.6%
Other values (6)	654	16.3%

Discount Band
Categorical

Missing

Distinct	3
Distinct (%)	0.5%
Missing	53
Missing (%)	7.6%
Memory size	5.6 KiB

High	245
Medium	242
Low	160

Length

Max length	6
Median length	4
Mean length	4.5007728
Min length	3

Characters and Unicode

Total characters	2912
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Low
2nd row	Low
3rd row	Low
4th row	Low
5th row	Low

Common Values

Value	Count	Frequency (%)
High	245	35.0%
Medium	242	34.6%
Low	160	22.9%
(Missing)	53	7.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
high	245	37.9%
medium	242	37.4%
low	160	24.7%

Most occurring characters

Value	Count	Frequency (%)
i	487	16.7%
H	245	8.4%
g	245	8.4%
h	245	8.4%
M	242	8.3%
e	242	8.3%
d	242	8.3%
u	242	8.3%
m	242	8.3%
L	160	5.5%
Other values (2)	320	11.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2912	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	487	16.7%
H	245	8.4%
g	245	8.4%
h	245	8.4%
M	242	8.3%
e	242	8.3%
d	242	8.3%
u	242	8.3%
m	242	8.3%
L	160	5.5%
Other values (2)	320	11.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2912	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	487	16.7%
H	245	8.4%
g	245	8.4%
h	245	8.4%
M	242	8.3%
e	242	8.3%
d	242	8.3%
u	242	8.3%
m	242	8.3%
L	160	5.5%
Other values (2)	320	11.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2912	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	487	16.7%
H	245	8.4%
g	245	8.4%
h	245	8.4%
M	242	8.3%
e	242	8.3%
d	242	8.3%
u	242	8.3%
m	242	8.3%
L	160	5.5%
Other values (2)	320	11.0%

Units Sold
Real number (ℝ)

Distinct	510
Distinct (%)	72.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1608.2943

Minimum	200
Maximum	4492.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 KiB

Quantile statistics

Minimum	200
5-th percentile	344.95
Q1	905
median	1542.5
Q3	2229.125
95-th percentile	2935.95
Maximum	4492.5
Range	4292.5
Interquartile range (IQR)	1324.125

Descriptive statistics

Standard deviation	867.42786
Coefficient of variation (CV)	0.53934648
Kurtosis	-0.315318
Mean	1608.2943
Median Absolute Deviation (MAD)	655.5
Skewness	0.43615356
Sum	1125806
Variance	752431.09
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
727	5	0.7%
2844	4	0.6%
1916	4	0.6%
663	4	0.6%
1743	4	0.6%
1496	4	0.6%
1372	3	0.4%
1366	3	0.4%
293	3	0.4%
1123	3	0.4%
Other values (500)	663	94.7%

Value	Count	Frequency (%)
200	1	0.1%
214	2	0.3%
218	1	0.1%
241	2	0.3%
245	1	0.1%
257	1	0.1%
259	1	0.1%
260	1	0.1%
263	2	0.3%
266	1	0.1%

Value	Count	Frequency (%)
4492.5	1	0.1%
4251	1	0.1%
4243.5	1	0.1%
4219.5	1	0.1%
4026	1	0.1%
3997.5	1	0.1%
3945	1	0.1%
3874.5	1	0.1%
3864	1	0.1%
3850.5	1	0.1%

Manufacturing Price
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	96.477143

Minimum	3
Maximum	260
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 KiB

Quantile statistics

Minimum	3
5-th percentile	3
Q1	5
median	10
Q3	250
95-th percentile	260
Maximum	260
Range	257
Interquartile range (IQR)	245

Descriptive statistics

Standard deviation	108.60261
Coefficient of variation (CV)	1.1256823
Kurtosis	-1.4289627
Mean	96.477143
Median Absolute Deviation (MAD)	7
Skewness	0.59258395
Sum	67534
Variance	11794.527
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
10	202	28.9%
120	109	15.6%
250	109	15.6%
260	94	13.4%
3	93	13.3%
5	93	13.3%

Value	Count	Frequency (%)
3	93	13.3%
5	93	13.3%
10	202	28.9%
120	109	15.6%
250	109	15.6%
260	94	13.4%

Value	Count	Frequency (%)
260	94	13.4%
250	109	15.6%
120	109	15.6%
10	202	28.9%
5	93	13.3%
3	93	13.3%

Sale Price
Real number (ℝ)

High correlation

Distinct	7
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	118.42857

Minimum	7
Maximum	350
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 KiB

Quantile statistics

Minimum	7
5-th percentile	7
Q1	12
median	20
Q3	300
95-th percentile	350
Maximum	350
Range	343
Interquartile range (IQR)	288

Descriptive statistics

Standard deviation	136.77551
Coefficient of variation (CV)	1.1549199
Kurtosis	-1.176789
Mean	118.42857
Median Absolute Deviation (MAD)	13
Skewness	0.77128187
Sum	82900
Variance	18707.541
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
20	100	14.3%
15	100	14.3%
350	100	14.3%
12	100	14.3%
125	100	14.3%
300	100	14.3%
7	100	14.3%

Value	Count	Frequency (%)
7	100	14.3%
12	100	14.3%
15	100	14.3%
20	100	14.3%
125	100	14.3%
300	100	14.3%
350	100	14.3%

Value	Count	Frequency (%)
350	100	14.3%
300	100	14.3%
125	100	14.3%
20	100	14.3%
15	100	14.3%
12	100	14.3%
7	100	14.3%

Gross Sales
Real number (ℝ)

High correlation

Distinct	550
Distinct (%)	78.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	182759.43

Minimum	1799
Maximum	1207500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 KiB

Quantile statistics

Minimum	1799
5-th percentile	5193.05
Q1	17391.75
median	37980
Q3	279025
95-th percentile	754250
Maximum	1207500
Range	1205701
Interquartile range (IQR)	261633.25

Descriptive statistics

Standard deviation	254262.28
Coefficient of variation (CV)	1.3912403
Kurtosis	2.0543006
Mean	182759.43
Median Absolute Deviation (MAD)	30747.5
Skewness	1.6739217
Sum	1.279316 × 10⁸
Variance	6.4649309 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37050	3	0.4%
738000	3	0.4%
22710	3	0.4%
4404	3	0.4%
82875	3	0.4%
26145	3	0.4%
349625	2	0.3%
24980	2	0.3%
921200	2	0.3%
196250	2	0.3%
Other values (540)	674	96.3%

Value	Count	Frequency (%)
1799	1	0.1%
1841	2	0.3%
1960	2	0.3%
2051	1	0.1%
2520	2	0.3%
2534	1	0.1%
2660	1	0.1%
2716	1	0.1%
3270	1	0.1%
3416	1	0.1%

Value	Count	Frequency (%)
1207500	1	0.1%
1140750	1	0.1%
1138050	1	0.1%
1048500	1	0.1%
1038100	2	0.3%
1006950	2	0.3%
1006600	1	0.1%
998200	2	0.3%
997850	1	0.1%
982450	1	0.1%

Discounts
Real number (ℝ)

High correlation Zeros

Distinct	515
Distinct (%)	73.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13150.355

Minimum	0
Maximum	149677.5
Zeros	53
Zeros (%)	7.6%
Negative	0
Negative (%)	0.0%
Memory size	5.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	800.32
median	2585.25
Q3	15956.344
95-th percentile	62832
Maximum	149677.5
Range	149677.5
Interquartile range (IQR)	15156.024

Descriptive statistics

Standard deviation	22962.929
Coefficient of variation (CV)	1.7461832
Kurtosis	7.9057124
Mean	13150.355
Median Absolute Deviation (MAD)	2328.57
Skewness	2.6850389
Sum	9205248.2
Variance	5.272961 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	53	7.6%
1218.6	3	0.4%
5690	3	0.4%
20139	3	0.4%
4400	2	0.3%
870.45	2	0.3%
5005.65	2	0.3%
3674.4	2	0.3%
14906.25	2	0.3%
21490	2	0.3%
Other values (505)	626	89.4%

Value	Count	Frequency (%)
0	53	7.6%
18.41	1	0.1%
25.34	1	0.1%
44.73	1	0.1%
48.15	1	0.1%
72.1	1	0.1%
91.92	2	0.3%
92.82	1	0.1%
110.46	1	0.1%
112.05	1	0.1%

Value	Count	Frequency (%)
149677.5	1	0.1%
125820	1	0.1%
119756	2	0.3%
115830	1	0.1%
112927.5	1	0.1%
111375	1	0.1%
109147.5	1	0.1%
106722	1	0.1%
106512	1	0.1%
105367.5	1	0.1%

Sales
Real number (ℝ)

High correlation

Distinct	559
Distinct (%)	79.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	169609.07

Minimum	1655.08
Maximum	1159200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 KiB

Quantile statistics

Minimum	1655.08
5-th percentile	4535.65
Q1	15928
median	35540.2
Q3	261077.5
95-th percentile	683574.75
Maximum	1159200
Range	1157544.9
Interquartile range (IQR)	245149.5

Descriptive statistics

Standard deviation	236726.35
Coefficient of variation (CV)	1.3957175
Kurtosis	2.1886331
Mean	169609.07
Median Absolute Deviation (MAD)	28716.7
Skewness	1.6962952
Sum	1.1872635 × 10⁸
Variance	5.6039363 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20794.8	2	0.3%
334302.5	2	0.3%
136560	2	0.3%
26945.6	2	0.3%
9662.4	2	0.3%
21801.6	2	0.3%
303688	2	0.3%
731472	2	0.3%
21700.8	2	0.3%
7707.35	2	0.3%
Other values (549)	680	97.1%

Value	Count	Frequency (%)
1655.08	1	0.1%
1685.6	2	0.3%
1730.54	1	0.1%
1763.86	1	0.1%
1822.59	1	0.1%
2293.2	2	0.3%
2335.76	1	0.1%
2367.4	1	0.1%
2508.66	1	0.1%
3139.2	1	0.1%

Value	Count	Frequency (%)
1159200	1	0.1%
1038082.5	1	0.1%
1035625.5	1	0.1%
1017338	2	0.3%
986811	2	0.3%
978236	2	0.3%
962500	1	0.1%
936138	1	0.1%
922680	1	0.1%
884205	1	0.1%

COGS
Real number (ℝ)

High correlation

Distinct	545
Distinct (%)	77.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	145475.21

Minimum	918
Maximum	950625
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 KiB

Quantile statistics

Minimum	918
5-th percentile	2449.5
Q1	7490
median	22506.25
Q3	245607.5
95-th percentile	608643.75
Maximum	950625
Range	949707
Interquartile range (IQR)	238117.5

Descriptive statistics

Standard deviation	203865.51
Coefficient of variation (CV)	1.4013762
Kurtosis	1.608463
Mean	145475.21
Median Absolute Deviation (MAD)	19576.25
Skewness	1.5490476
Sum	1.0183265 × 10⁸
Variance	4.1561145 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17430	4	0.6%
8655	3	0.4%
24700	3	0.4%
1101	3	0.4%
15140	3	0.4%
615000	3	0.4%
79560	3	0.4%
335640	2	0.3%
12490	2	0.3%
204720	2	0.3%
Other values (535)	672	96.0%

Value	Count	Frequency (%)
918	1	0.1%
1101	3	0.4%
1158	2	0.3%
1230	2	0.3%
1285	1	0.1%
1315	2	0.3%
1400	2	0.3%
1416	2	0.3%
1465	1	0.1%
1500	1	0.1%

Value	Count	Frequency (%)
950625	1	0.1%
948375	1	0.1%
897000	1	0.1%
873750	1	0.1%
771160	2	0.3%
748250	1	0.1%
748020	2	0.3%
747760	1	0.1%
741520	2	0.3%
741260	1	0.1%

Profit
Real number (ℝ)

High correlation

Distinct	557
Distinct (%)	79.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24133.86

Minimum	-40617.5
Maximum	262200
Zeros	5
Zeros (%)	0.7%
Negative	58
Negative (%)	8.3%
Memory size	5.6 KiB

Quantile statistics

Minimum	-40617.5
5-th percentile	-7849.25
Q1	2805.96
median	9242.2
Q3	22662
95-th percentile	117138.1
Maximum	262200
Range	302817.5
Interquartile range (IQR)	19856.04

Descriptive statistics

Standard deviation	42760.627
Coefficient of variation (CV)	1.7718105
Kurtosis	8.6786162
Mean	24133.86
Median Absolute Deviation (MAD)	7383.075
Skewness	2.7121513
Sum	16893702
Variance	1.8284712 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5	0.7%
10768.8	2	0.3%
6822.5	2	0.3%
7829.35	2	0.3%
11635.6	2	0.3%
2952.4	2	0.3%
6661.6	2	0.3%
165452	2	0.3%
47328	2	0.3%
-17481.25	2	0.3%
Other values (547)	677	96.7%

Value	Count	Frequency (%)
-40617.5	1	0.1%
-38046.25	1	0.1%
-35550	1	0.1%
-35262.5	1	0.1%
-33522.5	1	0.1%
-27693.75	1	0.1%
-25841.25	1	0.1%
-24160	1	0.1%
-23870	1	0.1%
-21560	2	0.3%

Value	Count	Frequency (%)
262200	1	0.1%
247500	1	0.1%
246178	2	0.3%
238791	2	0.3%
236716	2	0.3%
188378	1	0.1%
186407.5	2	0.3%
165452	2	0.3%
161020	1	0.1%
155250	1	0.1%

Date
Date

Distinct	16
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Memory size	5.6 KiB

Minimum	2013-09-01 00:00:00
Maximum	2014-12-01 00:00:00

Histogram with fixed size bins (bins=16)

Month Number
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.9

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1.95
Q1	5.75
median	9
Q3	10.25
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	4.5

Descriptive statistics

Standard deviation	3.3773206
Coefficient of variation (CV)	0.42750894
Kurtosis	-0.87915982
Mean	7.9
Median Absolute Deviation (MAD)	2.5
Skewness	-0.57829215
Sum	5530
Variance	11.406295
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
10	140	20.0%
12	105	15.0%
6	70	10.0%
9	70	10.0%
11	70	10.0%
1	35	5.0%
3	35	5.0%
7	35	5.0%
8	35	5.0%
2	35	5.0%
Other values (2)	70	10.0%

Value	Count	Frequency (%)
1	35	5.0%
2	35	5.0%
3	35	5.0%
4	35	5.0%
5	35	5.0%
6	70	10.0%
7	35	5.0%
8	35	5.0%
9	70	10.0%
10	140	20.0%

Value	Count	Frequency (%)
12	105	15.0%
11	70	10.0%
10	140	20.0%
9	70	10.0%
8	35	5.0%
7	35	5.0%
6	70	10.0%
5	35	5.0%
4	35	5.0%
3	35	5.0%

Month Name
Categorical

High correlation

Distinct	12
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	5.6 KiB

October	140
December	105
June	70
September	70
November	70
Other values (7)	245

Length

Max length	9
Median length	8
Mean length	6.6
Min length	3

Characters and Unicode

Total characters	4620
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	January
2nd row	January
3rd row	June
4th row	June
5th row	June

Common Values

Value	Count	Frequency (%)
October	140	20.0%
December	105	15.0%
June	70	10.0%
September	70	10.0%
November	70	10.0%
January	35	5.0%
March	35	5.0%
July	35	5.0%
August	35	5.0%
February	35	5.0%
Other values (2)	70	10.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
october	140	20.0%
december	105	15.0%
june	70	10.0%
september	70	10.0%
november	70	10.0%
january	35	5.0%
march	35	5.0%
july	35	5.0%
august	35	5.0%
february	35	5.0%
Other values (2)	70	10.0%

Most occurring characters

Value	Count	Frequency (%)
e	910	19.7%
r	560	12.1%
b	420	9.1%
c	280	6.1%
t	245	5.3%
m	245	5.3%
u	245	5.3%
o	210	4.5%
a	175	3.8%
O	140	3.0%
Other values (16)	1190	25.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4620	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	910	19.7%
r	560	12.1%
b	420	9.1%
c	280	6.1%
t	245	5.3%
m	245	5.3%
u	245	5.3%
o	210	4.5%
a	175	3.8%
O	140	3.0%
Other values (16)	1190	25.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4620	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	910	19.7%
r	560	12.1%
b	420	9.1%
c	280	6.1%
t	245	5.3%
m	245	5.3%
u	245	5.3%
o	210	4.5%
a	175	3.8%
O	140	3.0%
Other values (16)	1190	25.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4620	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	910	19.7%
r	560	12.1%
b	420	9.1%
c	280	6.1%
t	245	5.3%
m	245	5.3%
u	245	5.3%
o	210	4.5%
a	175	3.8%
O	140	3.0%
Other values (16)	1190	25.8%

Year
Categorical

High correlation

Distinct	2
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	5.6 KiB

2014	525
2013	175

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	2800
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2014
2nd row	2014
3rd row	2014
4th row	2014
5th row	2014

Common Values

Value	Count	Frequency (%)
2014	525	75.0%
2013	175	25.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2014	525	75.0%
2013	175	25.0%

Most occurring characters

Value	Count	Frequency (%)
2	700	25.0%
0	700	25.0%
1	700	25.0%
4	525	18.8%
3	175	6.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2800	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	700	25.0%
0	700	25.0%
1	700	25.0%
4	525	18.8%
3	175	6.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2800	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	700	25.0%
0	700	25.0%
1	700	25.0%
4	525	18.8%
3	175	6.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2800	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	700	25.0%
0	700	25.0%
1	700	25.0%
4	525	18.8%
3	175	6.2%

	Sales	COGS	Country	Discount Band	Discounts	Gross Sales	Manufacturing Price	Month Name	Month Number	Product	Profit	Sale Price	Segment	Units Sold	Year
Sales	1.000	0.971	0.066	0.123	0.773	0.999	0.030	0.068	-0.034	0.000	0.581	0.869	0.365	0.376	0.155
COGS	0.971	1.000	0.062	0.110	0.777	0.973	0.032	0.075	-0.023	0.000	0.474	0.852	0.390	0.365	0.111
Country	0.066	0.062	1.000	0.000	0.000	0.035	0.000	0.000	0.000	0.000	0.069	0.000	0.000	0.100	0.000
Discount Band	0.123	0.110	0.000	1.000	0.170	0.119	0.033	0.090	0.081	0.000	0.216	0.083	0.093	0.134	0.000
Discounts	0.773	0.777	0.000	0.170	1.000	0.791	0.057	0.086	0.008	0.000	0.350	0.707	0.256	0.272	0.088
Gross Sales	0.999	0.973	0.035	0.119	0.791	1.000	0.032	0.067	-0.030	0.000	0.576	0.870	0.377	0.377	0.087
Manufacturing Price	0.030	0.032	0.000	0.033	0.057	0.032	1.000	0.000	0.004	0.998	0.036	0.056	0.000	-0.023	0.000
Month Name	0.068	0.075	0.000	0.090	0.086	0.067	0.000	1.000	0.999	0.000	0.000	0.000	0.000	0.150	0.523
Month Number	-0.034	-0.023	0.000	0.081	0.008	-0.030	0.004	0.999	1.000	0.000	-0.044	0.000	0.000	-0.066	0.517
Product	0.000	0.000	0.000	0.000	0.000	0.000	0.998	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000
Profit	0.581	0.474	0.069	0.216	0.350	0.576	0.036	0.000	-0.044	0.000	1.000	0.525	0.374	0.295	0.000
Sale Price	0.869	0.852	0.000	0.083	0.707	0.870	0.056	0.000	0.000	0.000	0.525	1.000	0.848	-0.059	0.000
Segment	0.365	0.390	0.000	0.093	0.256	0.377	0.000	0.000	0.000	0.000	0.374	0.848	1.000	0.085	0.000
Units Sold	0.376	0.365	0.100	0.134	0.272	0.377	-0.023	0.150	-0.066	0.000	0.295	-0.059	0.085	1.000	0.095
Year	0.155	0.111	0.000	0.000	0.088	0.087	0.000	0.523	0.517	0.000	0.000	0.000	0.000	0.095	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	Segment	Country	Product	Discount Band	Units Sold	Manufacturing Price	Sale Price	Gross Sales	Sales	COGS	Profit	Date	Month Number	Month Name	Year
0	Government	Canada	Carretera	NaN	1618.5	3	20	32370.0	32370.0	16185.0	16185.0	2014-01-01	1	January	2014
1	Government	Germany	Carretera	NaN	1321.0	3	20	26420.0	26420.0	13210.0	13210.0	2014-01-01	1	January	2014
2	Midmarket	France	Carretera	NaN	2178.0	3	15	32670.0	32670.0	21780.0	10890.0	2014-06-01	6	June	2014
3	Midmarket	Germany	Carretera	NaN	888.0	3	15	13320.0	13320.0	8880.0	4440.0	2014-06-01	6	June	2014
4	Midmarket	Mexico	Carretera	NaN	2470.0	3	15	37050.0	37050.0	24700.0	12350.0	2014-06-01	6	June	2014
5	Government	Germany	Carretera	NaN	1513.0	3	350	529550.0	529550.0	393380.0	136170.0	2014-12-01	12	December	2014
6	Midmarket	Germany	Montana	NaN	921.0	5	15	13815.0	13815.0	9210.0	4605.0	2014-03-01	3	March	2014
7	Channel Partners	Canada	Montana	NaN	2518.0	5	12	30216.0	30216.0	7554.0	22662.0	2014-06-01	6	June	2014
8	Government	France	Montana	NaN	1899.0	5	20	37980.0	37980.0	18990.0	18990.0	2014-06-01	6	June	2014
9	Channel Partners	Germany	Montana	NaN	1545.0	5	12	18540.0	18540.0	4635.0	13905.0	2014-06-01	6	June	2014

	Segment	Country	Product	Discount Band	Units Sold	Manufacturing Price	Sale Price	Gross Sales	Discounts	Sales	COGS	Profit	Date	Month Number	Month Name	Year
690	Government	United States of America	VTT	High	267.0	250	20	5340.0	801.00	4539.00	2670.0	1869.00	2013-10-01	10	October	2013
691	Midmarket	Germany	VTT	High	1175.0	250	15	17625.0	2643.75	14981.25	11750.0	3231.25	2014-10-01	10	October	2014
692	Enterprise	Canada	VTT	High	2954.0	250	125	369250.0	55387.50	313862.50	354480.0	-40617.50	2013-11-01	11	November	2013
693	Enterprise	Germany	VTT	High	552.0	250	125	69000.0	10350.00	58650.00	66240.0	-7590.00	2014-11-01	11	November	2014
694	Government	France	VTT	High	293.0	250	20	5860.0	879.00	4981.00	2930.0	2051.00	2014-12-01	12	December	2014
695	Small Business	France	Amarilla	High	2475.0	260	300	742500.0	111375.00	631125.00	618750.0	12375.00	2014-03-01	3	March	2014
696	Small Business	Mexico	Amarilla	High	546.0	260	300	163800.0	24570.00	139230.00	136500.0	2730.00	2014-10-01	10	October	2014
697	Government	Mexico	Montana	High	1368.0	5	7	9576.0	1436.40	8139.60	6840.0	1299.60	2014-02-01	2	February	2014
698	Government	Canada	Paseo	High	723.0	10	7	5061.0	759.15	4301.85	3615.0	686.85	2014-04-01	4	April	2014
699	Channel Partners	United States of America	VTT	High	1806.0	250	12	21672.0	3250.80	18421.20	5418.0	13003.20	2014-05-01	5	May	2014

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions